Previous | Table of Contents | Next |
If the Move selection after Enter function is enabled, this value controls the direction the selection cursor moves after you press Enter in the current cell. Valid values are
0 | Down |
1 | Right |
2 | Up |
3 | Left |
IV-25 | Hive: | HKEY_CURRENT_USER |
Key: | Software\Microsoft\Office\8.0\Excel\Microsoft Excel | |
Value Name: | DefFileMRU | |
Data Type: | REG_DWORD | |
Value: | 0x4 |
This value controls the number of most recently used files to display under the File Menu.
IV-26 | Hive: | HKEY_CURRENT_USER |
Key: | Software\Microsoft\Office\8.0\Excel\Microsoft Excel | |
Value Name: | Font | |
Data Type: | REG_SZ | |
Value: | Arial,10 |
This value specifics the default font and size to use for new worksheets. It also controls the default font used for the Normal style and for the row and column headings.
IV-27 | Hive: | HKEY_CURRENT_USER |
Key: | Software\Microsoft\Office\8.0\Excel\Microsoft Excel | |
Value Name: | MenuKey | |
Data Type: | REG_DWORD | |
Value: | 47 |
This value specifies the key to use to activate Excel menus or Help functions; normally this value is a forward slash (/), which is the menu key used for Lotus 1-2-3. This is the value of the key in ASCII.
IV-28 | Hive: | HKEY_CURRENT_USER |
Key: | Software\Microsoft\Office\8.0\Excel\Microsoft Excel | |
Value Name: | Randomize | |
Data Type: | REG_DWORD | |
Value: | 1 |
This value causes Microsoft Excel to generate a unique random number each time you use the RAND function.
IV-29 The next two registry keys control where Excels dialog boxes appear on the screen. Excel updates these values when it closes.
Hive: | HKEY_CURRENT_USER |
Key: | Software\Microsoft\Office\8.0\Excel\Microsoft Excel |
Value Name: | StickyPtX |
Data Type: | REG_DWORD |
Value: | 479 |
IV-30 | Hive: | HKEY_CURRENT_USER |
Key: | Software\Microsoft\Office\8.0\Excel\Microsoft Excel | |
Value Name: | StickyPtY | |
Data Type: | REG_DWORD | |
Value: | 241 |
IV-31 | Hive: | HKEY_CURRENT_USER |
Key: | Software\Microsoft\Office\8.0\Excel\Microsoft Excel | |
Value Name: | SortCaseSensitive | |
Data Type: | REG_DWORD | |
Value: | 0x0 |
This value controls the default Case Sensitive setting for the sorting algorithm that Microsoft Excel uses.
IV-32 | Hive: | HKEY_CURRENT_USER |
Key: | Software\Microsoft\Office\8.0\Excel\Microsoft Excel | |
Value Name: | CustomSortOrder | |
Data Type: | REG_DWORD | |
Value: | 0x0 |
This value controls the default setting of the First key sort order, which appears under the Sort/Options dialog box.
IV-33 | Hive: | HKEY_CURRENT_USER |
Key: | Software\Microsoft\Office\8.0\Excel\Microsoft Excel | |
Value Name: | AutoFormat | |
Data Type: | REG_DWORD | |
Value: | 0x2 |
This value is the default AutoFormat choice that appears under the AutoFormat dialog box. The value specifies an index number that points to a Table Format.
IV-34 | Hive: | HKEY_CURRENT_USER |
Key: | Software\Microsoft\Office\8.0\Excel\Microsoft Excel | |
Value Name: | AutoFormat Options | |
Data Type: | REG_DWORD | |
Value: | 0x3f (63) |
This value controls the format options specified in the AutoFormat registry key; the options correspond to the attributes in the AutoFormat dialog box. The available options are
1 | Number |
2 | Font |
4 | Alignment |
8 | Border |
16 | Patterns |
32 | Width/Height |
Previous | Table of Contents | Next |